<?php
/**
** @Project: NUKEVIET SUPPORT ONLINE
** @Author: Dark Emperor (contact@vgtmedia.com.vn)
** @Copyright: VGTMEDIA
** @Craetdate: 14.02.2011
** @Website: http://vgtmedia.com.vn
*/
if ( ! defined( 'NV_IS_FILE_MODULES' ) ) die( 'Stop!!!' );

$sql_drop_module = array();

$sql_drop_module[] = "DROP TABLE IF EXISTS `" . $db_config['prefix'] . "_" . $lang . "_" . $module_data . "`;";
$sql_drop_module[] = "DROP TABLE IF EXISTS `" . $db_config['prefix'] . "_" . $lang . "_" . $module_data . "_group`;";

$sql_create_module = $sql_drop_module;

$sql_create_module[] = "CREATE TABLE `" . $db_config['prefix'] . "_" . $lang . "_" . $module_data . "` (
  `id` int(11) NOT NULL auto_increment,
  `idgroup` varchar(255) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `phone` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `yahoo_item` varchar(100) NOT NULL,
  `yahoo_type` varchar(2) NOT NULL,
  `weight` smallint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM";

$sql_create_module[] = "CREATE TABLE `" . $db_config['prefix'] . "_" . $lang . "_" . $module_data . "_group` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `weight` smallint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM";

$sql_create_module[] = "INSERT INTO `" . NV_PREFIXLANG . "_" . $module_data . "`
(`id`, `idgroup`, `title`, `phone`, `email`,`yahoo_item`, `yahoo_type`, `weight`) VALUES 
(NULL, '1', 'Mr Dark Emperor', '0909 009 213','contact@vgtmedia.com.vn','darkemperordt', '1','1'),
(NULL, '1', 'Mr Dark Emperor', '0909 009 213','contact@vgtmedia.com.vn','darkemperordt', '1','2'),
(NULL, '2', 'Mr Dark Emperor', '0909 009 213','contact@vgtmedia.com.vn','darkemperordt', '1','3'),
(NULL, '2', 'Mr Dark Emperor', '0909 009 213','contact@vgtmedia.com.vn','darkemperordt', '1','4'),
(NULL, '3', 'Mr Dark Emperor', '0909 009 213','contact@vgtmedia.com.vn','darkemperordt', '1','5'),
(NULL, '3', 'Mr Dark Emperor', '0909 009 213','contact@vgtmedia.com.vn','darkemperordt', '1','6')";

$sql_create_module[] = "INSERT INTO `" . NV_PREFIXLANG . "_" . $module_data . "_group` 
(`id`, `title`,`weight`) VALUES 
(NULL, 'Dịch vụ','1'),
(NULL, 'Tư vấn khách hàng','2'),
(NULL, 'Kỹ thuật','3')"; 
?>